| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Matt Ellis
Infinity Engine
2
   |
Posted - 2012.11.20 10:43:00 -
[1] - Quote
if you wanna import prices of things automatically, then you can use the market API to do this..
I use them myself when working out fuel costs, and production costs.
Quote:=importXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=4246","evec_api/marketstat/type/sell/min")
For instance, that in there, is the import for Minmitar fuel blocks, through sell orders
typeid: the id of the product you want to grab
List of Type IDs
sell/min: obviously, this is the type of order, so sell or buy, and the min,max or average i think..
I use Googledocs for mine, but bear in mind, i think there is a limit to the amount of XML imports you can do in a file... |
Matt Ellis
Infinity Engine
8
|
Posted - 2012.11.29 12:10:00 -
[2] - Quote
Nahla, while trying to use your spread to calc profits, i noticed there is an error with your working for 'PPD Fullerine Fibres'. You have it down as needing 100 of each c50 and c60, where it is actually 300 C50 and 100 C60. Almost had me investing in a potentially loss making reaction there.. hehe. |
Matt Ellis
Infinity Engine
8
|
Posted - 2012.11.29 13:40:00 -
[3] - Quote
Nalha Saldana wrote:Matt Ellis wrote:Nahla, while trying to use your spread to calc profits, i noticed there is an error with your working for 'PPD Fullerine Fibres'. You have it down as needing 100 of each c50 and c60, where it is actually 300 C50 and 100 C60. Almost had me investing in a potentially loss making reaction there.. hehe. Im so sorry, the whole hybrid reactions part is new and I havent personally used it yet so there might be more errors in it. Thanks for letting me know tho, its fixed now!
Don't be! I'm building my own little spread for complex reactions so i'll let you know if there are any more when i get that done..:D |
Matt Ellis
Infinity Engine
9
|
Posted - 2012.11.29 13:45:00 -
[4] - Quote
Oh, and good job on the spread though, just trying to pick the best money spinner for me..:D |
Matt Ellis
Infinity Engine
10
|
Posted - 2012.12.04 10:23:00 -
[5] - Quote
Right click the Cell -> Conditional Formatting.
Set it so if it is 'Less Than' 0, the text colour is red.. :D |
Matt Ellis
Infinity Engine
13
|
Posted - 2012.12.05 10:48:00 -
[6] - Quote
enterprisePSI wrote:Thank you very much!
Not a problem. You need any more help, let me know :D |
| |
|